Data Exchange in the Presence of Queries with Arithmetic Comparisons

نویسندگان

  • Foto Afrati
  • Chen Li
  • Vassia Pavlaki
چکیده

In this paper we study the problem of data exchange and query answering in the presence of arithmetic comparisons (ACs). The contributions of this work are the following: a) we extend the work in [FKMP03] by assuming source-to-target constraints, target constraints and queries to include ACs, b) we give an algebraic specification to compute a universal solution using a variant of the chase procedure (this in fact states by itself a contribution of this work since it is the first chase procedure in the literature that deals with arithmetic comparisons), c) we study how to compute the certain answers of a conjunctive query with ACs (CQAC) by using a universal solution and d) we study the computational complexity of computing the certain answers in this setting, e) we investigate how to use typed information to reduce the complexity of query answering, and f) we examine special cases where computing the certain answers can be done in polynomial time. Of independent interest is a test for checking the containment between two unions of CQACs.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Data Exchange with Arithmetic Comparisons∗

In this paper, the problem of data exchange in the presence of arithmetic comparisons is studied. For this purpose, tuple generating dependencies with arithmetic comparisons (tgd-AC) and arithmetic comparison generating dependencies (acgd) are introduced to capture the need to use arithmetic comparisons in source-totarget and in target constraints (both in their antecedent and in their conseque...

متن کامل

Rewriting queries using views in the presence of arithmetic comparisons

We consider the problem of answering queries using views, where queries and views are conjunctive queries with arithmetic comparisons over dense orders. Previous work only considered limited variants of this problem, without giving a complete solution. We first show that obtaining equivalent rewritings for conjunctive queries with arithmetic comparisons is decidable. Then we consider the proble...

متن کامل

Finding Equivalent Rewritings in the Presence of Arithmetic Comparisons

The problem of rewriting queries using views has received significant attention because of its applications in a wide variety of datamanagement problems. For select-project-join SQL (a.k.a. conjunctive) queries and views, there are efficient algorithms in the literature, which find equivalent and maximally contained rewritings. In the presence of arithmetic comparisons (ACs) the problem becomes...

متن کامل

ارائه روشی پویا جهت پاسخ به پرس‌وجوهای پیوسته تجمّعی اقتضایی

Data Streams are infinite, fast, time-stamp data elements which are received explosively. Generally, these elements need to be processed in an online, real-time way. So, algorithms to process data streams and answer queries on these streams are mostly one-pass. The execution of such algorithms has some challenges such as memory limitation, scheduling, and accuracy of answers. They will be more ...

متن کامل

Improvement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation

A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2006